/**
 * Copyright (c) 2016-2019 九点科技 All rights reserved.
 *
 * http://www.9dyun.cn
 *
 * 版权所有，侵权必究！
 */
package com.dian.modules.inv.dao;

import com.dian.modules.inv.entity.OutLineEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dian.modules.inv.vo.GoodsStockVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 出库单明细
 *
 * @author xiaolai
 * @email xiaolai@9dyun.cn
 * @date 2019-06-11 00:16:18
 */
@Mapper
public interface OutLineDao extends BaseMapper<OutLineEntity> {
    /**
     * 查询指定商品本月有效出库数量
     * @param outMonth       出库月份
     * @param goodsId       商品Id
     * @param colorNumber   商品色号
     * @param itemGrade     商品等级
     * @return
     */
    GoodsStockVO queryOutGoodsQty(
            @Param("warehouseId")Long warehouseID,
            @Param("outMonth")String outMonth,
            @Param("goodsId")Long goodsId,
            @Param("colorNumber")String colorNumber,
            @Param("itemGrade")Integer itemGrade
    );
}
